Tabela Holiday

Definicja tabeli Holiday

Name

Holiday

Code

Holiday

Comment

PL: Opis dni swiatecznych
EN: Holiday day definition


Lista kolumn tabeli Holiday

Name

Code

HolidayID

HolidayID

FrequencyID

FrequencyID

ShortName

ShortName

Description

Description

Day

Day

Month

Month

Year

Year

WeekDay

WeekDay

Code

Code

FullName

FullName

Active

Active


Kolumna HolidayID tabeli Holiday

Definicja kolumny HolidayID tabeli Holiday

Name

HolidayID

Code

HolidayID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FrequencyID tabeli Holiday

Definicja kolumny FrequencyID tabeli Holiday

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ShortName tabeli Holiday

Definicja kolumny ShortName tabeli Holiday

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(124)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna Description tabeli Holiday

Definicja kolumny Description tabeli Holiday

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Day tabeli Holiday

Definicja kolumny Day tabeli Holiday

Name

Day

Code

Day

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Month tabeli Holiday

Definicja kolumny Month tabeli Holiday

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Year tabeli Holiday

Definicja kolumny Year tabeli Holiday

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WeekDay tabeli Holiday

Definicja kolumny WeekDay tabeli Holiday

Name

WeekDay

Code

WeekDay

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli Holiday

Definicja kolumny Code tabeli Holiday

Name

Code

Code

Code

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna FullName tabeli Holiday

Definicja kolumny FullName tabeli Holiday

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Active tabeli Holiday

Definicja kolumny Active tabeli Holiday

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli Holiday

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Holiday

Definicja klucza Identifier_1 tabeli Holiday

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment